www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/khhj.cpp

    // khhj.cpp : implementation file
//

#include "stdafx.h"
#include "khmanager.h"
#include "khhj.h"
#include "xkh.h"
#include "ado.h"
#include "xlxr.h"
#include "lxrxx.h"
#include "qlxr.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
//ado rsthj;
CString bgdh;
/////////////////////////////////////////////////////////////////////////////
// khhj dialog


khhj::khhj(CWnd* pParent /*=NULL*/)
	: CDialog(khhj::IDD, pParent)
{
	//{{AFX_DATA_INIT(khhj)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void khhj::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(khhj)
	DDX_Control(pDX, IDC_EDIT9, m_edit9);
	DDX_Control(pDX, IDC_EDIT8, m_edit8);
	DDX_Control(pDX, IDC_EDIT7, m_edit7);
	DDX_Control(pDX, IDC_EDIT6, m_edit6);
	DDX_Control(pDX, IDC_EDIT5, m_edit5);
	DDX_Control(pDX, IDC_EDIT4, m_edit4);
	DDX_Control(pDX, IDC_EDIT3, m_edit3);
	DDX_Control(pDX, IDC_EDIT2, m_edit2);
	DDX_Control(pDX, IDC_EDIT10, m_edit10);
	DDX_Control(pDX, IDC_EDIT1, m_edit1);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(khhj, CDialog)
	//{{AFX_MSG_MAP(khhj)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// khhj message handlers

BOOL khhj::OnInitDialog() 
{
	CDialog::OnInitDialog();
	ado rst;
	rst.Open("select * from tb_khxx",adCmdText);
	int count=rst.GetRecordCount();
	int i;
	for(i=1;i<=count;i++)
	{
		this->m_com1.AddString(rst.GetFieldValue("khxx_gsdh"));
		rst.Move(i);
	}
	this->m_edit1.EnableWindow(false);
	this->m_edit2.EnableWindow(false);
	this->m_edit3.EnableWindow(false);
	this->m_edit4.EnableWindow(false);
	this->m_edit5.EnableWindow(false);
	this->m_edit6.EnableWindow(false);
	this->m_edit7.EnableWindow(false);
	this->m_edit8.EnableWindow(false);
	this->m_edit9.EnableWindow(false);
	this->m_edit10.EnableWindow(false);
rst.close();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void khhj::OnButton4() 
{
this->EndDialog(true);	
}

void khhj::texttowin()
{
	this->m_edit1.SetWindowText(edit1);
	this->m_edit2.SetWindowText(edit2);
	this->m_edit3.SetWindowText(edit3);
	this->m_edit4.SetWindowText(edit4);
	this->m_edit5.SetWindowText(edit5);
	this->m_edit6.SetWindowText(edit6);
	this->m_edit7.SetWindowText(edit7);
	this->m_edit8.SetWindowText(edit8);
	this->m_edit9.SetWindowText(edit9);
	this->m_edit10.SetWindowText(edit10);
}
void khhj::datatotext()
{


}
void khhj::OnButton5() 
{
	
	ado rst1;
	this->m_com1.GetWindowText(bgdh);
	if(bgdh.IsEmpty())
	{return;}
	CString sql;
	sql.Format("select * from tb_khxx where khxx_gsdh='%s'",bgdh);
	rst1.Open(sql,adCmdText);
	edit1=rst1.GetFieldValue("khxx_id");
	edit2=rst1.GetFieldValue("khxx_qydz");
	edit3=rst1.GetFieldValue("khxx_frdb");
	edit4=rst1.GetFieldValue("khxx_yhzh");
	edit5=rst1.GetFieldValue("khxx_lxr");
	edit6=rst1.GetFieldValue("khxx_lxrdh");
	edit7=rst1.GetFieldValue("khxx_mc");
	edit8=rst1.GetFieldValue("khxx_khyh");
	edit9=rst1.GetFieldValue("khxx_nsh");
	edit10=rst1.GetFieldValue("khxx_ICcard");
	
	this->texttowin();
	
	rst1.close();
	
}

void khhj::OnButton2() 
{
	CString ss,sid;
	this->m_edit1.GetWindowText(sid);
	if(sid.IsEmpty())
	{return;}
xkh k;
	ado rst;
	
	
	ss.Format("select * from tb_khxx where khxx_id='%s'",sid);
	rst.rstOpen(ss);

k.edit1=rst.GetFieldValue("khxx_id");
k.edit8=rst.GetFieldValue("khxx_mc");
k.com1=rst.GetFieldValue("khxx_qyxz");
k.com2=rst.GetFieldValue("khxx_qylx");
k.com5=rst.GetFieldValue("khxx_qyzx");
k.edit2=rst.GetFieldValue("khxx_qydz");
k.com3=rst.GetFieldValue("khxx_szsf");
k.edit9=rst.GetFieldValue("khxx_szcs");
k.edit3=rst.GetFieldValue("khxx_gsyb");
k.edit10=rst.GetFieldValue("khxx_frdb");
k.edit12=rst.GetFieldValue("khxx_khyh");
k.edit4=rst.GetFieldValue("khxx_yhzh");
k.edit11=rst.GetFieldValue("khxx_nsh");
k.edit13=rst.GetFieldValue("khxx_ICcard");
k.edit5=rst.GetFieldValue("khxx_gswz");
k.edit14=rst.GetFieldValue("khxx_gsdh");
k.edit6=rst.GetFieldValue("khxx_gscz");
k.edit15=rst.GetFieldValue("khxx_lxr");
k.edit7=rst.GetFieldValue("khxx_lxrdh");
k.com4=rst.GetFieldValue("khxx_khjb");
k.edit16=rst.GetFieldValue("khxx_bz");
	rst.close();

k.DoModal();	

	
}

void khhj::OnButton3() 
{
	/*
	CString ss2,sname;
	this->m_edit5.GetWindowText(sname);
	if(sname.IsEmpty())
	{return;}
	xlxr l;
	ado rst2;

	ss2.Format("select * from tb_Client_lxrxx where lxrxx_xm='%s'",sname);
rst2.rstOpen(ss2);

l.edit1=rst2.GetFieldValue("lxrxx_id");
l.com1=rst2.GetFieldValue("lxrxx_qymc");
l.edit2=rst2.GetFieldValue("lxrxx_xm");
l.com2=rst2.GetFieldValue("lxrxx_xb");
l.edit3=rst2.GetFieldValue("lxrxx_nl");
l.com3=rst2.GetFieldValue("lxrxx_zw");
l.edit4=rst2.GetFieldValue("lxrxx_bgdh");
l.edit5=rst2.GetFieldValue("lxrxx_Email");
l.edit6=rst2.GetFieldValue("lxrxx_sj");
l.date1=rst2.GetFieldValue("lxrxx_csny");

l.edit7=rst2.GetFieldValue("lxrxx_grjj");
l.date2=rst2.GetFieldValue("lxrxx_djrq");
l.edit8=rst2.GetFieldValue("lxrxx_xxdjr");
l.edit9=rst2.GetFieldValue("lxrxx_bz");
rst2.close();
l.DoModal();
	*/
	qlxr l;
	l.DoModal();
}